package cn.dnui_yxk801.dnuifood_16110100801.controller;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class RecordSQLiteOpenHelper extends SQLiteOpenHelper {
    private static String DB_NAME="temp.db";
    private static String TABLE_NAME="records";
    private static Integer VERSION=1;
    private static String ID="id";
    private static String NAME="name";
    public RecordSQLiteOpenHelper(Context context) {
        super(context,DB_NAME,null,VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table "+TABLE_NAME+" ("+ID+" integer primary key autoincrement, "+NAME+" varchar(100))");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
        onCreate(db);
    }
}
